/*
 Navicat MySQL Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50716
 Source Host           : localhost
 Source Database       : api_os

 Target Server Type    : MySQL
 Target Server Version : 50716
 File Encoding         : utf-8

 Date: 02/28/2017 22:36:41 PM
*/

SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `api`
-- ----------------------------
DROP TABLE IF EXISTS `api`;
CREATE TABLE `api` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `projId` int(11) DEFAULT '0' COMMENT '所属项目id',
  `groupId` int(11) DEFAULT '0' COMMENT '所属组/模块id',
  `name` varchar(100) DEFAULT '' COMMENT 'api名称',
  `path` varchar(100) DEFAULT '' COMMENT 'api请求地址',
  `status` int(1) DEFAULT '1' COMMENT 'api状态 1启用 2维护 3停用',
  `method` int(1) DEFAULT '1' COMMENT '请求方式 1POST 2GET 3PUT 4DELETE 5PATCH 6OPTIONS',
  `type` int(1) DEFAULT '1' COMMENT '请求参数类型 1json 2key-val',
  `param` text COMMENT '请求的源数据',
  `result` text COMMENT '请求返回的结果',
  `remark` text COMMENT '请求返回的说明',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `api`
-- ----------------------------
BEGIN;
INSERT INTO `api` VALUES ('11', '8', '8', '??????', '/AppInfo/GetPayBackMsg', '1', '2', '1', '', '<p>{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"text\"</span>:<span class=\"json_string\">\"AAA\"</span><br>}</p>', '<p>text ????html??</p>', '1484574819', '0', '0', '0', '0'), ('12', '8', '8', '??????', '/AppInfo/AppSetingInfo', '1', '2', '1', '', '<p><span>{</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\"json_key\">\"AppName\"</span><span>:</span><span class=\"json_string\">\"\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\"json_key\">\"QQqun\"</span><span>:</span><span class=\"json_string\">\"\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\"json_key\">\"QQ1\"</span><span>:</span><span class=\"json_string\">\"\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\"json_key\">\"QQ2\"</span><span>:</span><span class=\"json_string\">\"\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\"json_key\">\"AliPay\"</span><span>:</span><span class=\"json_string\">\"\"</span><br><span>}</span></p>', '<p>AppName ????</p><p>QQqun Q?</p><p>QQ1 ??1</p><p>QQ2 ??2</p><p>AliPay ?????</p>', '1484576388', '0', '0', '0', '0'), ('13', '8', '8', '??', '/user', '1', '1', '2', '<p>userName=&amp;Pwd=&amp;DeviceToken=</p>', '<p>{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"isOk\"</span>:<span class=\"json_number\">1</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"Msg\"</span>:<span class=\"json_null\">\"\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"Data\"</span>:<span data-type=\"object\"><span class=\"iconfont icon-shanchu\" ng-click=\"hide($event)\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"Uid\"</span>:<span class=\"json_number\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"MemberType\"</span>:<span class=\"json_number\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"userName\"</span>:<span class=\"json_string\">\"\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"TokenKey\"</span>:<span class=\"json_string\">\"\"</span><br>&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>}</p>', '<p>isOk 1?? 0??</p><p>Msg ???</p><p>Data ??</p><p>&nbsp; &nbsp; Uid ??id</p><p>&nbsp; &nbsp; MemberType ????</p><p>&nbsp; &nbsp; userName ???</p><p>&nbsp; &nbsp; TokenKey &nbsp;token</p>', '1484579540', '0', '0', '0', '0'), ('14', '8', '10', '??????', '/deliver/Mydanhao?SessionKey={token}&p={pageIndex}', '1', '2', '1', '', '<div class=\"third-part\"><article ng-class=\"{\'hidden\':projectApiTestCtrl.isHeader}\"><div class=\"back-result-content\" id=\"apiResult_js\"><span data-type=\"object\" class=\"ng-scope\">{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"isEnd\"</span>:<span class=\"json_number\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"Data\"</span>:<span data-type=\"array\" data-size=\"10\"><span class=\"iconfont icon-shanchu\" ng-click=\"hide($event)\"></span>[<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span data-type=\"object\"><span class=\"iconfont icon-shanchu\" ng-click=\"hide($event)\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"id\"</span>:<span class=\"json_number\">469</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"CodeName\"</span>:<span class=\"json_string\">\"????\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"DeliverTime\"</span>:<span class=\"json_string\">\"2016/12/25 17:00:42\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"danhaoNumber\"</span>:<span class=\"json_string\">\"150384852047\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"BeginAddress\"</span>:<span class=\"json_string\">\"???????? ????? ?????\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"ReceiptAddress\"</span>:<span class=\"json_string\">\"??? ??? ???\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"createTime\"</span>:<span class=\"json_string\">\"2016/10/31 23:46:25\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"Isdeliver\"</span>:<span class=\"json_number\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\"json_key\">\"DealType\"</span>:<span class=\"json_number\">-1</span><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>&nbsp;&nbsp;&nbsp;&nbsp;]</span><br>}</span></div></article></div><div class=\"part test-history-part\" data-ng-class=\"{\'hidden\':projectApiTestCtrl.detail.testHistory.length<=0}\"></div>', '<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>p ??</p><div><br></div>', '1484630394', '1484631552', '0', '0', '0'), ('15', '8', '10', '??', '/deliver/Complaint', '1', '1', '2', '<p>id=&amp;SessionKey=&amp;ComplaintType=</p>', '', '<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>id ??id</p><p>ComplaintType ????</p>', '1484630953', '0', '0', '0', '0'), ('16', '8', '10', 'weqwe', 'qweqwe', '1', '1', '1', 'qweq', '', '', '1484631098', '0', '0', '0', '1'), ('17', '8', '10', '1', '3', '1', '1', '1', '4', '', '', '1484631432', '0', '0', '0', '1'), ('18', '8', '10', '3', '4', '1', '1', '1', '132', '123', '123', '1484631483', '1484631502', '0', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `apienvironment`
-- ----------------------------
DROP TABLE IF EXISTS `apienvironment`;
CREATE TABLE `apienvironment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '组/模块名',
  `uri` varchar(500) DEFAULT '' COMMENT '前置uri地址',
  `projId` int(11) DEFAULT '0' COMMENT '所属项目id',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `apienvironment`
-- ----------------------------
BEGIN;
INSERT INTO `apienvironment` VALUES ('3', '????', 'http://125.88.186.84:97', '8', '1484574709', '0', '0', '0', '0'), ('4', '????', 'http://125.88.186.84:99', '8', '1484574726', '0', '0', '0', '0'), ('5', '11111', 'weqwe', '8', '1487312167', '0', '1', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `apigroup`
-- ----------------------------
DROP TABLE IF EXISTS `apigroup`;
CREATE TABLE `apigroup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '组/模块名',
  `projId` int(11) DEFAULT '0' COMMENT '所属项目id',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `apigroup`
-- ----------------------------
BEGIN;
INSERT INTO `apigroup` VALUES ('8', '???', '8', '1484574657', '1487311008', '0', '1', '0'), ('9', '???', '8', '1484574666', '0', '0', '0', '0'), ('10', '???', '8', '1484574674', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `apilog`
-- ----------------------------
DROP TABLE IF EXISTS `apilog`;
CREATE TABLE `apilog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `projId` int(11) DEFAULT '0' COMMENT '所属项目的id',
  `apiId` int(11) DEFAULT '0' COMMENT '所属接口id',
  `type` int(1) DEFAULT '1' COMMENT '日志类型 1请求历史 2操作api日志',
  `path` varchar(5000) DEFAULT '' COMMENT '请求地址',
  `method` int(1) DEFAULT '1' COMMENT '请求方式 1POST 2GET 3PUT 4DELETE 5PATCH 6OPTIONS',
  `param` text COMMENT '请求参数',
  `code` int(11) DEFAULT '0' COMMENT '请求返回的状态码',
  `header` varchar(5000) DEFAULT NULL,
  `context` text COMMENT '请求返回的结果/操作api的日志',
  `op` int(1) DEFAULT '0' COMMENT '日志类型 1新增 2修改 3删除 0无状态',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `apilog`
-- ----------------------------
BEGIN;
INSERT INTO `apilog` VALUES ('3', '0', '11', '2', '', '1', null, '0', null, '{\"result\":\"<p>{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"text\\\"</span>:<span class=\\\"json_string\\\">\\\"AAA\\\"</span><br>}</p>\",\"path\":\"/AppInfo/GetPayBackMsg\",\"projId\":\"8\",\"method\":\"2\",\"param\":\"\",\"createTime\":1484574819,\"groupId\":8,\"name\":\"??????\",\"remark\":\"<p>text ????html??</p>\",\"id\":11,\"status\":\"1\"}', '1', '1484574819', '0', '0', '0', '0'), ('4', '0', '12', '2', '', '1', null, '0', null, '{\"result\":\"<p><span>{</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\\\"json_key\\\">\\\"AppName\\\"</span><span>:</span><span class=\\\"json_string\\\">\\\"\\\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\\\"json_key\\\">\\\"QQqun\\\"</span><span>:</span><span class=\\\"json_string\\\">\\\"\\\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\\\"json_key\\\">\\\"QQ1\\\"</span><span>:</span><span class=\\\"json_string\\\">\\\"\\\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\\\"json_key\\\">\\\"QQ2\\\"</span><span>:</span><span class=\\\"json_string\\\">\\\"\\\"</span><span>,</span><br><span>&nbsp;&nbsp;&nbsp;&nbsp;</span><span class=\\\"json_key\\\">\\\"AliPay\\\"</span><span>:</span><span class=\\\"json_string\\\">\\\"\\\"</span><br><span>}</span></p>\",\"path\":\"/AppInfo/AppSetingInfo\",\"projId\":\"8\",\"method\":\"2\",\"param\":\"\",\"createTime\":1484576388,\"groupId\":8,\"name\":\"??????\",\"remark\":\"<p>AppName ????</p><p>QQqun Q?</p><p>QQ1 ??1</p><p>QQ2 ??2</p><p>AliPay ?????</p>\",\"id\":12,\"status\":\"1\"}', '1', '1484576388', '0', '0', '0', '0'), ('5', '0', '12', '1', 'http://125.88.186.84:97/AppInfo/AppSetingInfo', '2', '', '0', null, '{\"QQ1\":\"123123\",\"QQqun\":\"12345678910\",\"QQ2\":\"12365489x\",\"AliPay\":\"kaihuan52@163.com\",\"AppName\":\"??????????-??????\"}', '0', '1484577905', '0', '0', '0', '0'), ('6', '0', '12', '1', 'http://125.88.186.84:97/AppInfo/AppSetingInfo', '2', '', '0', null, '{\"QQ1\":\"123123\",\"QQqun\":\"12345678910\",\"QQ2\":\"12365489x\",\"AliPay\":\"kaihuan52@163.com\",\"AppName\":\"??????????-??????\"}', '0', '1484579035', '0', '0', '0', '0'), ('7', '0', '12', '1', 'http://125.88.186.84:97/AppInfo/AppSetingInfo', '2', '', '0', null, '{\"QQ1\":\"123123\",\"QQqun\":\"12345678910\",\"QQ2\":\"12365489x\",\"AliPay\":\"kaihuan52@163.com\",\"AppName\":\"??????????-??????\"}', '0', '1484579038', '0', '0', '0', '0'), ('8', '0', '13', '2', '', '1', null, '0', null, '{\"result\":\"<p>{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"isOk\\\"</span>:<span class=\\\"json_number\\\">1</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Msg\\\"</span>:<span class=\\\"json_null\\\">\\\"\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Data\\\"</span>:<span data-type=\\\"object\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Uid\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"MemberType\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"userName\\\"</span>:<span class=\\\"json_string\\\">\\\"\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"TokenKey\\\"</span>:<span class=\\\"json_string\\\">\\\"\\\"</span><br>&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>}</p>\",\"path\":\"/user\",\"projId\":\"8\",\"method\":\"1\",\"param\":\"<p>userName=&amp;Pwd=&amp;DeviceToken=</p>\",\"createTime\":1484579540,\"groupId\":8,\"name\":\"??\",\"remark\":\"<p>isOk 1?? 0??</p><p>Msg ???</p><p>Data ??</p><p>&nbsp; &nbsp; Uid ??id</p><p>&nbsp; &nbsp; MemberType ????</p><p>&nbsp; &nbsp; userName ???</p><p>&nbsp; &nbsp; TokenKey &nbsp;token</p>\",\"id\":13,\"type\":\"2\",\"status\":\"1\"}', '1', '1484579540', '0', '0', '0', '0'), ('9', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=test1&Pwd=1111111&DeviceToken=13123213', '0', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484580201', '0', '0', '0', '0'), ('10', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=test1&Pwd=111111&DeviceToken=13123213', '0', null, '{\"Msg\":null,\"isOk\":1,\"Data\":{\"Uid\":1,\"MemberType\":2,\"TokenKey\":\"ad1cc38b-f79c-4a6d-9cf3-26da1b9b976f\",\"userName\":\"test1\"}}', '0', '1484580208', '0', '0', '0', '0'), ('11', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=test1&Pwd=111111&DeviceToken=13123213', '0', null, '{\"status\":0,\"message\":\"???????????\",\"data\":\"com.mashape.unirest.http.exceptions.UnirestException: java.lang.RuntimeException: java.lang.RuntimeException: org.json.JSONException: A JSONArray text must start with \'[\' at 1 [character 2 line 1]\"}', '0', '1484580223', '0', '0', '0', '0'), ('12', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=test1&Pwd=111111&DeviceToken=13123213', '0', null, '{\"Msg\":null,\"isOk\":1,\"Data\":{\"Uid\":1,\"MemberType\":2,\"TokenKey\":\"ad1cc38b-f79c-4a6d-9cf3-26da1b9b976f\",\"userName\":\"test1\"}}', '0', '1484580236', '0', '0', '0', '0'), ('13', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=123&Pwd=3&DeviceToken=123', '0', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484580440', '0', '0', '0', '0'), ('14', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=123&Pwd=3&DeviceToken=123', '0', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484580480', '0', '0', '0', '0'), ('15', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=123&Pwd=3&DeviceToken=123', '0', null, '{\"status\":0,\"message\":\"???????????\",\"data\":\"com.mashape.unirest.http.exceptions.UnirestException: org.apache.http.conn.HttpHostConnectException: Connect to 125.88.186.84:99 [/125.88.186.84] failed: Connection refused\"}', '0', '1484580496', '0', '0', '0', '0'), ('16', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=123&Pwd=3&DeviceToken=123', '0', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484580505', '0', '0', '0', '0'), ('17', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=123&Pwd=3&DeviceToken=123', '0', null, '{\"status\":0,\"message\":\"???????????\",\"data\":\"com.mashape.unirest.http.exceptions.UnirestException: java.lang.RuntimeException: java.lang.RuntimeException: org.json.JSONException: A JSONArray text must start with \'[\' at 1 [character 2 line 1]\"}', '0', '1484580508', '0', '0', '0', '0'), ('18', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=1&Pwd=3&DeviceToken=3', '0', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484581854', '0', '0', '0', '0'), ('19', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583306', '0', '0', '0', '0'), ('20', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'java.net.SocketException: Connection reset', '0', '1484583371', '0', '0', '0', '0'), ('21', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'java.net.SocketException: Connection reset', '0', '1484583497', '0', '0', '0', '0'), ('22', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583504', '0', '0', '0', '0'), ('23', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583562', '0', '0', '0', '0'), ('24', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583693', '0', '0', '0', '0'), ('25', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583770', '0', '0', '0', '0'), ('26', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583855', '0', '0', '0', '0'), ('27', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583938', '0', '0', '0', '0'), ('28', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484583998', '0', '0', '0', '0'), ('29', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484584062', '0', '0', '0', '0'), ('30', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484584173', '0', '0', '0', '0'), ('31', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'org.apache.http.conn.HttpHostConnectException: Connect to 125.88.186.84:99 [/125.88.186.84] failed: Connection refused', '0', '1484584181', '0', '0', '0', '0'), ('32', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'org.apache.http.conn.HttpHostConnectException: Connect to 125.88.186.84:99 [/125.88.186.84] failed: Connection refused', '0', '1484584185', '0', '0', '0', '0'), ('33', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'java.net.SocketException: Connection reset', '0', '1484584246', '0', '0', '0', '0'), ('34', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'org.apache.http.conn.HttpHostConnectException: Connect to 125.88.186.84:99 [/125.88.186.84] failed: Connection refused', '0', '1484584270', '0', '0', '0', '0'), ('35', '0', '13', '1', 'http://125.88.186.84:99/user', '1', 'userName=&Pwd=&DeviceToken=', '500', null, 'java.net.SocketException: Connection reset', '0', '1484584372', '0', '0', '0', '0'), ('36', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', null, '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484584417', '0', '0', '0', '0'), ('37', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[61], Date=[Mon, 16 Jan 2017 16:34:25 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484584466', '0', '0', '0', '0'), ('38', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=test1&Pwd=111111&DeviceToken=12312313', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[122], Date=[Mon, 16 Jan 2017 16:35:18 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":null,\"isOk\":1,\"Data\":{\"Uid\":1,\"MemberType\":2,\"TokenKey\":\"ad1cc38b-f79c-4a6d-9cf3-26da1b9b976f\",\"userName\":\"test1\"}}', '0', '1484584520', '0', '0', '0', '0'), ('39', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=test1&Pwd=111111&DeviceToken=12312313', '500', '', 'java.lang.RuntimeException: java.lang.RuntimeException: org.json.JSONException: A JSONArray text must start with \'[\' at 1 [character 2 line 1]', '0', '1484584537', '0', '0', '0', '0'), ('40', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[61], Date=[Tue, 17 Jan 2017 03:54:52 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484625294', '0', '0', '0', '0'), ('41', '0', '12', '1', 'http://125.88.186.84:97/AppInfo/AppSetingInfo', '2', '', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[147], Date=[Tue, 17 Jan 2017 05:07:13 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"QQ1\":\"123123\",\"QQqun\":\"12345678910\",\"QQ2\":\"12365489x\",\"AliPay\":\"kaihuan52@163.com\",\"AppName\":\"??????????-??????\"}', '0', '1484629635', '0', '0', '0', '0'), ('42', '8', '14', '2', '', '1', null, '0', null, '{\"result\":\"<div class=\\\"third-part\\\"><article ng-class=\\\"{\'hidden\':projectApiTestCtrl.isHeader}\\\"><div class=\\\"back-result-content\\\" id=\\\"apiResult_js\\\"><span data-type=\\\"object\\\" class=\\\"ng-scope\\\">{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"isEnd\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Data\\\"</span>:<span data-type=\\\"array\\\" data-size=\\\"10\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>[<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span data-type=\\\"object\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"id\\\"</span>:<span class=\\\"json_number\\\">469</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"CodeName\\\"</span>:<span class=\\\"json_string\\\">\\\"????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DeliverTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/12/25 17:00:42\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"danhaoNumber\\\"</span>:<span class=\\\"json_string\\\">\\\"150384852047\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"BeginAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"???????? ????? ?????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"ReceiptAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"??? ??? ???\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"createTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/10/31 23:46:25\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Isdeliver\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DealType\\\"</span>:<span class=\\\"json_number\\\">-1</span><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>&nbsp;&nbsp;&nbsp;&nbsp;]</span><br>}</span></div></article></div><div class=\\\"part test-history-part\\\" data-ng-class=\\\"{\'hidden\':projectApiTestCtrl.detail.testHistory.length<=0}\\\"></div>\",\"path\":\"/deliver/Mydanhao?SessionKey={token}&p={pageIndex}\",\"projId\":\"8\",\"method\":\"1\",\"param\":\"\",\"createTime\":1484630394,\"groupId\":10,\"name\":\"??????\",\"remark\":\"<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>p ??</p><div><br></div>\",\"id\":14,\"type\":\"1\",\"status\":\"1\"}', '1', '1484630394', '0', '0', '0', '0'), ('43', '8', '14', '2', '', '1', null, '0', null, '{\"result\":\"<div class=\\\"third-part\\\"><article ng-class=\\\"{\'hidden\':projectApiTestCtrl.isHeader}\\\"><div class=\\\"back-result-content\\\" id=\\\"apiResult_js\\\"><span data-type=\\\"object\\\" class=\\\"ng-scope\\\">{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"isEnd\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Data\\\"</span>:<span data-type=\\\"array\\\" data-size=\\\"10\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>[<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span data-type=\\\"object\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"id\\\"</span>:<span class=\\\"json_number\\\">469</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"CodeName\\\"</span>:<span class=\\\"json_string\\\">\\\"????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DeliverTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/12/25 17:00:42\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"danhaoNumber\\\"</span>:<span class=\\\"json_string\\\">\\\"150384852047\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"BeginAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"???????? ????? ?????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"ReceiptAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"??? ??? ???\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"createTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/10/31 23:46:25\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Isdeliver\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DealType\\\"</span>:<span class=\\\"json_number\\\">-1</span><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>&nbsp;&nbsp;&nbsp;&nbsp;]</span><br>}</span></div></article></div><div class=\\\"part test-history-part\\\" data-ng-class=\\\"{\'hidden\':projectApiTestCtrl.detail.testHistory.length<=0}\\\"></div>\",\"path\":\"/deliver/Mydanhao?SessionKey={token}&p={pageIndex}\",\"method\":\"1\",\"param\":\"\",\"name\":\"??????\",\"remark\":\"<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>p ??</p><div><br></div>\",\"updateTime\":1484630745,\"id\":\"14\",\"type\":\"1\",\"status\":\"1\"}', '2', '1484630745', '0', '0', '0', '0'), ('44', '8', '14', '2', '', '1', null, '0', null, '{\"result\":\"<div class=\\\"third-part\\\"><article ng-class=\\\"{\'hidden\':projectApiTestCtrl.isHeader}\\\"><div class=\\\"back-result-content\\\" id=\\\"apiResult_js\\\"><span data-type=\\\"object\\\" class=\\\"ng-scope\\\">{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"isEnd\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Data\\\"</span>:<span data-type=\\\"array\\\" data-size=\\\"10\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>[<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span data-type=\\\"object\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"id\\\"</span>:<span class=\\\"json_number\\\">469</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"CodeName\\\"</span>:<span class=\\\"json_string\\\">\\\"????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DeliverTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/12/25 17:00:42\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"danhaoNumber\\\"</span>:<span class=\\\"json_string\\\">\\\"150384852047\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"BeginAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"???????? ????? ?????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"ReceiptAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"??? ??? ???\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"createTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/10/31 23:46:25\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Isdeliver\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DealType\\\"</span>:<span class=\\\"json_number\\\">-1</span><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>&nbsp;&nbsp;&nbsp;&nbsp;]</span><br>}</span></div></article></div><div class=\\\"part test-history-part\\\" data-ng-class=\\\"{\'hidden\':projectApiTestCtrl.detail.testHistory.length<=0}\\\"></div>\",\"path\":\"/deliver/Mydanhao?SessionKey={token}&p={pageIndex}\",\"method\":\"1\",\"param\":\"\",\"name\":\"??????\",\"remark\":\"<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>p ??</p><div><br></div>\",\"updateTime\":1484630867,\"id\":\"14\",\"type\":\"1\",\"status\":\"1\"}', '2', '1484630867', '0', '0', '0', '0'), ('45', '8', '15', '2', '', '1', null, '0', null, '{\"result\":\"\",\"path\":\"/deliver/Complaint\",\"projId\":\"8\",\"method\":\"1\",\"param\":\"<p>id=&amp;SessionKey=&amp;ComplaintType=</p>\",\"createTime\":1484630953,\"groupId\":10,\"name\":\"??\",\"remark\":\"<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>id ??id</p><p>ComplaintType ????</p>\",\"id\":15,\"type\":\"2\",\"status\":\"1\"}', '1', '1484630953', '0', '0', '0', '0'), ('46', '8', '16', '2', '', '1', null, '0', null, '{\"result\":\"\",\"path\":\"qweqwe\",\"projId\":\"8\",\"method\":\"1\",\"param\":\"qweq\",\"createTime\":1484631098,\"groupId\":10,\"name\":\"weqwe\",\"remark\":\"\",\"id\":16,\"type\":\"1\",\"status\":\"1\"}', '1', '1484631098', '0', '0', '0', '0'), ('47', '8', '17', '2', '', '1', null, '0', null, '{\"result\":\"\",\"path\":\"3\",\"projId\":\"8\",\"method\":\"1\",\"param\":\"4\",\"createTime\":1484631432,\"groupId\":10,\"name\":\"1\",\"remark\":\"\",\"id\":17,\"type\":\"1\",\"status\":\"1\"}', '1', '1484631432', '0', '0', '0', '0'), ('48', '8', '18', '2', '', '1', null, '0', null, '{\"result\":\"123\",\"path\":\"4\",\"projId\":\"8\",\"method\":\"1\",\"param\":\"132\",\"createTime\":1484631483,\"groupId\":10,\"name\":\"3\",\"remark\":\"123\",\"id\":18,\"type\":\"1\",\"status\":\"1\"}', '1', '1484631483', '0', '0', '0', '0'), ('49', '8', '18', '2', '', '1', null, '0', null, '{\"result\":\"123\",\"path\":\"4\",\"method\":\"1\",\"param\":\"132\",\"name\":\"3\",\"remark\":\"123\",\"updateTime\":1484631502,\"id\":\"18\",\"type\":\"1\",\"status\":\"1\"}', '2', '1484631502', '0', '0', '0', '0'), ('50', '8', '18', '2', '', '1', null, '0', null, null, '3', '1484631519', '0', '0', '0', '0'), ('51', '8', '17', '2', '', '1', null, '0', null, null, '3', '1484631527', '0', '0', '0', '0'), ('52', '8', '16', '2', '', '1', null, '0', null, null, '3', '1484631530', '0', '0', '0', '0'), ('53', '8', '14', '2', '', '1', null, '0', null, '{\"result\":\"<div class=\\\"third-part\\\"><article ng-class=\\\"{\'hidden\':projectApiTestCtrl.isHeader}\\\"><div class=\\\"back-result-content\\\" id=\\\"apiResult_js\\\"><span data-type=\\\"object\\\" class=\\\"ng-scope\\\">{<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"isEnd\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Data\\\"</span>:<span data-type=\\\"array\\\" data-size=\\\"10\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>[<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span data-type=\\\"object\\\"><span class=\\\"iconfont icon-shanchu\\\" ng-click=\\\"hide($event)\\\"></span>{<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"id\\\"</span>:<span class=\\\"json_number\\\">469</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"CodeName\\\"</span>:<span class=\\\"json_string\\\">\\\"????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DeliverTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/12/25 17:00:42\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"danhaoNumber\\\"</span>:<span class=\\\"json_string\\\">\\\"150384852047\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"BeginAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"???????? ????? ?????\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"ReceiptAddress\\\"</span>:<span class=\\\"json_string\\\">\\\"??? ??? ???\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"createTime\\\"</span>:<span class=\\\"json_string\\\">\\\"2016/10/31 23:46:25\\\"</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"Isdeliver\\\"</span>:<span class=\\\"json_number\\\">0</span>,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span class=\\\"json_key\\\">\\\"DealType\\\"</span>:<span class=\\\"json_number\\\">-1</span><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</span><br>&nbsp;&nbsp;&nbsp;&nbsp;]</span><br>}</span></div></article></div><div class=\\\"part test-history-part\\\" data-ng-class=\\\"{\'hidden\':projectApiTestCtrl.detail.testHistory.length<=0}\\\"></div>\",\"path\":\"/deliver/Mydanhao?SessionKey={token}&p={pageIndex}\",\"method\":\"2\",\"param\":\"\",\"name\":\"??????\",\"remark\":\"<p>SessionKey 7f5cd2e9-08b5-45cd-8b14-564775dc3241<br></p><p>p ??</p><div><br></div>\",\"updateTime\":1484631552,\"id\":\"14\",\"type\":\"1\",\"status\":\"1\"}', '2', '1484631552', '0', '0', '0', '0'), ('54', '0', '15', '1', 'http://125.88.186.84:97/deliver/Complaint', '1', 'id=&SessionKey=&ComplaintType=', '500', '', 'java.lang.RuntimeException: java.lang.RuntimeException: org.json.JSONException: A JSONArray text must start with \'[\' at 1 [character 2 line 1]', '0', '1484639850', '0', '0', '0', '0'), ('55', '0', '15', '1', 'http://125.88.186.84:97/deliver/Complaint', '1', 'id=&SessionKey=&ComplaintType=', '500', '', 'java.lang.RuntimeException: java.lang.RuntimeException: org.json.JSONException: A JSONArray text must start with \'[\' at 1 [character 2 line 1]', '0', '1484639850', '0', '0', '0', '0'), ('56', '0', '15', '1', 'http://125.88.186.84:97/deliver/Complaint', '1', 'id=&SessionKey=&ComplaintType=', '500', '', 'java.lang.RuntimeException: java.lang.RuntimeException: org.json.JSONException: A JSONArray text must start with \'[\' at 1 [character 2 line 1]', '0', '1484639972', '0', '0', '0', '0'), ('57', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[61], Date=[Thu, 19 Jan 2017 05:30:36 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1484803839', '0', '0', '0', '0'), ('58', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=1111&Pwd=111&DeviceToken=h', '500', '', 'org.apache.http.conn.HttpHostConnectException: Connect to 125.88.186.84:97 [/125.88.186.84] failed: Network is unreachable', '0', '1487296387', '0', '0', '0', '0'), ('59', '0', '12', '1', 'http://125.88.186.84:97/AppInfo/AppSetingInfo', '2', '', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[147], Date=[Fri, 17 Feb 2017 05:23:13 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"QQ1\":\"123123\",\"QQqun\":\"12345678910\",\"QQ2\":\"12365489x\",\"AliPay\":\"kaihuan52@163.com\",\"AppName\":\"??????????-??????\"}', '0', '1487309057', '0', '0', '0', '0'), ('60', '0', '11', '1', 'http://125.88.186.84:97/AppInfo/GetPayBackMsg', '2', '', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[174], Date=[Fri, 17 Feb 2017 05:24:03 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"text\":\"?????<br/>1??10??2?<br/>2??20??5?<br/>3??50??15?<br/>4??100?50<br/>\"}', '0', '1487309106', '0', '0', '0', '0'), ('61', '0', '12', '1', 'http://125.88.186.84:97/AppInfo/AppSetingInfo', '2', '', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[147], Date=[Fri, 17 Feb 2017 06:08:13 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"QQ1\":\"123123\",\"QQqun\":\"12345678910\",\"QQ2\":\"12365489x\",\"AliPay\":\"kaihuan52@163.com\",\"AppName\":\"??????????-??????\"}', '0', '1487311757', '0', '0', '0', '0'), ('62', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[61], Date=[Fri, 17 Feb 2017 06:12:50 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1487312034', '0', '0', '0', '0'), ('63', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=&Pwd=&DeviceToken=', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[61], Date=[Fri, 17 Feb 2017 06:15:42 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1487312206', '0', '0', '0', '0'), ('64', '0', '13', '1', 'http://125.88.186.84:97/user', '1', 'userName=2222&Pwd=000&DeviceToken=fhgfgh', '200', '{Cache-Control=[private], Server=[Microsoft-IIS/7.5], X-AspNet-Version=[4.0.30319], Content-Length=[61], Date=[Fri, 17 Feb 2017 06:16:03 GMT], Content-Type=[application/json; charset=utf-8], X-AspNetMvc-Version=[3.0], X-Powered-By=[ASP.NET]}', '{\"Msg\":\"??????????\",\"isOk\":0,\"Data\":null}', '0', '1487312227', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `department`
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '部门名称',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `department`
-- ----------------------------
BEGIN;
INSERT INTO `department` VALUES ('1', 'aaa', '0', '0', '0', '0', '0'), ('2', 'ccc', '0', '0', '0', '0', '0'), ('3', '1EEE', '0', '0', '0', '0', '0'), ('4', 'CCCCC', '0', '0', '0', '0', '0'), ('5', 'EEE', '0', '1486541080', '0', '1', '1'), ('6', '3331', '0', '1486539731', '0', '1', '0'), ('7', '132', '1486539100', '1486563726', '1', '1', '1'), ('8', '1111', '1486563731', '0', '1', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `devices`
-- ----------------------------
DROP TABLE IF EXISTS `devices`;
CREATE TABLE `devices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(200) DEFAULT '' COMMENT '设备号码',
  `sn` varchar(200) DEFAULT '' COMMENT 'sn序列号',
  `imei` varchar(200) DEFAULT '' COMMENT 'imei号',
  `clientId` varchar(200) DEFAULT '' COMMENT '绑定的用户id',
  `garrisonId` int(11) DEFAULT '0' COMMENT '驻防配置',
  `garrisonStatus` int(1) DEFAULT '1' COMMENT '1驻防/0撤防状态',
  `workStatus` int(1) DEFAULT '1' COMMENT '1激活/0未激活 工作状态',
  `lockStatus` int(1) DEFAULT '1' COMMENT '1激活/0未激活 锁定状态',
  `name` varchar(100) DEFAULT '' COMMENT '部门名称',
  `sort` int(11) DEFAULT '0' COMMENT '排序',
  `createTime` int(11) DEFAULT '0',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `devices`
-- ----------------------------
BEGIN;
INSERT INTO `devices` VALUES ('1', '123', '13', '123', '', '8', '1', '1', '1', '', '0', '1486611161', '0', '1', '0', '0'), ('2', '865536022569534', '865536022569534', '865536022569534', '', '7', '1', '1', '1', '', '99', '1486620623', '0', '1', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `devices_garrison_config`
-- ----------------------------
DROP TABLE IF EXISTS `devices_garrison_config`;
CREATE TABLE `devices_garrison_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) DEFAULT '' COMMENT '驻防名称',
  `range` int(11) DEFAULT '0' COMMENT '驻防围栏半径(单位：米)',
  `createTime` int(11) DEFAULT '0' COMMENT '????',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `devices_garrison_config`
-- ----------------------------
BEGIN;
INSERT INTO `devices_garrison_config` VALUES ('1', 'AAA', '300', '1486602332', '0', '1', '0', '1'), ('2', '???', '30', '1486602582', '1486610102', '1', '1', '0'), ('3', 'VVV3', '60', '1486602627', '1486603527', '1', '1', '1'), ('4', 'VV1', '300', '1486603069', '1486603517', '1', '1', '1'), ('5', 'WE', '600', '1486603534', '0', '1', '0', '1'), ('6', '????', '50', '1486610123', '0', '1', '0', '0'), ('7', '???', '100', '1486610141', '1486610157', '1', '1', '0'), ('8', '???', '200', '1486610185', '0', '1', '0', '0'), ('9', '???', '300', '1486610274', '0', '1', '0', '0'), ('10', '???', '500', '1486610288', '0', '1', '0', '0'), ('11', '213123', '233', '1487311285', '0', '1', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `isicon` int(1) DEFAULT '1',
  `icon` varchar(200) DEFAULT '' COMMENT '菜单图标',
  `name` varchar(200) DEFAULT '' COMMENT '菜单名称',
  `width` varchar(200) DEFAULT '' COMMENT '窗体宽度(预留)',
  `height` varchar(200) DEFAULT '' COMMENT '窗体高度(预留)',
  `iconclass` varchar(200) DEFAULT 'layui-icon' COMMENT '图标样式 禁止修改',
  `url` varchar(500) DEFAULT '' COMMENT '菜单路径',
  `sort` int(11) DEFAULT '0' COMMENT '排序数字越大越靠前',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  `iconbg` varchar(50) DEFAULT '#60b979' COMMENT '图标背景色',
  `target` varchar(50) DEFAULT '_blank' COMMENT '窗体打开方式',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `menu`
-- ----------------------------
BEGIN;
INSERT INTO `menu` VALUES ('19', '1', '&#xe60f', '????', '', '', 'layui-icon', '/core/menu', '0', '0', '0', '0', '0', '0', '#60b979', '_blank'), ('20', '1', '&#xe62a', '????', '', '', 'layui-icon', '/core/department', '100', '0', '0', '0', '0', '0', '#60b979', '_blank'), ('21', '1', '&#xe61b', '????', '', '', 'layui-icon', '/core/users', '99', '0', '0', '0', '0', '0', '#60b979', '_blank'), ('23', '1', '&#xe60b', '????', '', '', 'layui-icon', '/core/role', '98', '0', '0', '0', '0', '0', '#60b979', '_blank'), ('24', '1', '&#xe615', '33', '', '', 'layui-icon', '4', '0', '1486541027', '1486541038', '1', '1', '1', '#60b979', '_blank'), ('25', '1', '&#xe631', '????', '', '', 'layui-icon', '/business/devices', '1000', '1486545267', '0', '1', '0', '0', '#60b979', '_blank'), ('26', '1', '&#xe617', '????', '', '', 'layui-icon', '/business/devices/position', '999', '1486545337', '0', '1', '0', '0', '#60b979', '_blank'), ('27', '1', '&#xe62c', '????', '', '', 'layui-icon', '/business/devices/garrison', '998', '1486563924', '0', '1', '0', '0', '#60b979', '_blank'), ('28', '1', '&#xe64c', 'API??', '', '', 'layui-icon', '/business/api', '999', '1487291712', '0', '1', '0', '0', '#60b979', '_blank');
COMMIT;

-- ----------------------------
--  Table structure for `proj`
-- ----------------------------
DROP TABLE IF EXISTS `proj`;
CREATE TABLE `proj` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '项目名称',
  `version` varchar(20) DEFAULT '' COMMENT '版本号',
  `type` int(1) DEFAULT '0' COMMENT '0通用 1App 2PC 3Web 4硬件/物联网 5其他',
  `remark` varchar(500) DEFAULT '' COMMENT '项目说明',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `proj`
-- ----------------------------
BEGIN;
INSERT INTO `proj` VALUES ('8', '????', 'V1.0.2', '1', '??????', '1484574624', '1487310977', '0', '1', '0'), ('9', 'aaa', '12', '0', '123', '1487296349', '0', '1', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '' COMMENT '角色名称',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `role`
-- ----------------------------
BEGIN;
INSERT INTO `role` VALUES ('4', '?????', '0', '1486566075', '0', '1', '0'), ('5', 'VVV', '1486602664', '1486603057', '1', '1', '1'), ('6', 'AAAA', '1486602828', '1486603055', '1', '1', '1'), ('7', 'VVVVS', '1486603047', '1486603052', '1', '1', '1');
COMMIT;

-- ----------------------------
--  Table structure for `role_fk_menu`
-- ----------------------------
DROP TABLE IF EXISTS `role_fk_menu`;
CREATE TABLE `role_fk_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `roleId` int(11) DEFAULT '0' COMMENT '角色Id',
  `menuId` int(11) DEFAULT '0' COMMENT '菜单Id',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `role_fk_menu`
-- ----------------------------
BEGIN;
INSERT INTO `role_fk_menu` VALUES ('23', '2', '21', '0', '0', '0', '0', '1'), ('24', '2', '23', '0', '0', '0', '0', '1'), ('25', '2', '19', '0', '0', '0', '0', '1'), ('26', '2', '20', '0', '0', '0', '0', '1'), ('27', '2', '21', '0', '0', '0', '0', '1'), ('28', '2', '23', '0', '0', '0', '0', '1'), ('29', '2', '19', '0', '0', '0', '0', '1'), ('30', '2', '20', '0', '0', '0', '0', '0'), ('31', '2', '19', '0', '0', '0', '0', '0'), ('32', '3', '21', '0', '0', '0', '0', '1'), ('33', '3', '23', '0', '0', '0', '0', '1'), ('34', '3', '21', '0', '0', '0', '0', '1'), ('35', '3', '23', '0', '0', '0', '0', '1'), ('36', '3', '19', '0', '0', '0', '0', '1'), ('37', '3', '21', '0', '0', '0', '0', '0'), ('38', '3', '23', '0', '0', '0', '0', '0'), ('39', '3', '19', '0', '0', '0', '0', '0'), ('40', '4', '20', '0', '0', '0', '0', '1'), ('41', '4', '21', '0', '0', '0', '0', '1'), ('42', '4', '23', '0', '0', '0', '0', '1'), ('43', '4', '19', '0', '0', '0', '0', '1'), ('44', '4', '25', '0', '0', '0', '0', '1'), ('45', '4', '26', '0', '0', '0', '0', '1'), ('46', '4', '20', '0', '0', '0', '0', '1'), ('47', '4', '21', '0', '0', '0', '0', '1'), ('48', '4', '23', '0', '0', '0', '0', '1'), ('49', '4', '19', '0', '0', '0', '0', '1'), ('50', '4', '25', '0', '0', '0', '0', '1'), ('51', '4', '26', '0', '0', '0', '0', '1'), ('52', '4', '27', '0', '0', '0', '0', '1'), ('53', '4', '20', '0', '0', '0', '0', '1'), ('54', '4', '21', '0', '0', '0', '0', '1'), ('55', '4', '23', '0', '0', '0', '0', '1'), ('56', '4', '19', '0', '0', '0', '0', '1'), ('57', '4', '25', '0', '0', '0', '0', '0'), ('58', '4', '26', '0', '0', '0', '0', '0'), ('59', '4', '28', '0', '0', '0', '0', '0'), ('60', '4', '27', '0', '0', '0', '0', '0'), ('61', '4', '20', '0', '0', '0', '0', '0'), ('62', '4', '21', '0', '0', '0', '0', '0'), ('63', '4', '23', '0', '0', '0', '0', '0'), ('64', '4', '19', '0', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `users`
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(50) DEFAULT NULL,
  `departmentId` int(11) DEFAULT '0' COMMENT '部门id',
  `roleId` int(11) DEFAULT '0' COMMENT '????id',
  `salt` varchar(20) DEFAULT '',
  `password` varchar(100) DEFAULT NULL,
  `trueName` varchar(50) DEFAULT NULL,
  `status` int(1) DEFAULT '1' COMMENT '1 启用 0禁用',
  `createTime` int(11) DEFAULT '0' COMMENT '创建时间',
  `updateTime` int(11) DEFAULT '0' COMMENT '修改时间',
  `createId` int(11) DEFAULT '0' COMMENT '创建人',
  `updateId` int(11) DEFAULT '0' COMMENT '修改人',
  `isDel` int(1) DEFAULT '0' COMMENT '删除标识 1删除 0正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `users`
-- ----------------------------
BEGIN;
INSERT INTO `users` VALUES ('1', 'Taller', '2', '4', '777084', '7823c627f7a8b4d7226d63e5fdeb060b', 'Taller', '1', '1484636624', '0', '0', '0', '0'), ('8', '3333', '3', '3', '554752', '', 'AAAAAA', '1', '0', '0', '0', '0', '1'), ('9', '123', '3', '2', '374341', '', '123123', '1', '0', '0', '0', '0', '1'), ('10', '432432', '6', '2', '137491', '', '3213', '1', '0', '0', '0', '0', '1'), ('11', 'tal123123', '7', '4', '932653', 'e99cb44255a8730ba3d87146c85f89b2', '3213123', '1', '1486541100', '1486541118', '1', '1', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
